Jump to content

Before And After the Dot


This topic is 4360 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Very vague on what you are trying to do.

Leftwords, Middlewords, and Rightwords (Maybe)

Post an example of the text involved.

Note: Show what you have now, and what you are wanting to Parse out of the existing text. Give use more than one example so that we can see what patterns are involved.

Lee

Link to comment
Share on other sites

Before dot =

Left ( FileName ; Position ( FileName ; "." ; 1 ;  1 ) - 1 )





After dot =




Right ( FileName ; Length ( FileName ) - Position ( FileName ; "." ; 1 ;  1 ) )

Could I use a similar calculation to break down a text field that contains text either side of " - " into two seperate fields? The text either side of the " - " can be multiple words.

Link to comment
Share on other sites

Could I use a similar calculation to break down a text field that contains text either side of " - " into two seperate fields?

Sure - provided you adjust for the length of " - " in the second formula.

Another option is to substitute " - " with a carriage return, then use GetValue() to extract a single line.

Link to comment
Share on other sites

Sure - provided you adjust for the length of " - " in the second formula.

Another option is to substitute " - " with a carriage return, then use GetValue() to extract a single line.

I'm having a little trouble understanding the required calculation. Obviously my calculation must differ from the OP's solution because I have multiple words either side of " - ". In the original solution above what do the multiple "1" values denote?

Link to comment
Share on other sites

This topic is 4360 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.