Need some serious help parsing text

[madhatt]

Ok, So below is an example text string i'll be working with

2~11~Test ID~4/19/2012 12:23:51 PM~USER~123.123.123.123

what I am trying to do is to get each section of the text (between each ~) into it's own field.



I can do it to the first section with the following function

Left( Text; Position( Text; "~"; 1; 1 ) - 1 )

But everything fails after that

So in the end I am needed to create 6 fields. and those fields "using this example" would show the following.

1. 2
   
2. 11
   
3. Test ID
   
4. 4/19/2012 12:23:51 PM
   
5. USER
   
6. 123.123.123.123
   

Any help would be appreciated!

[mr_vodka]

From your sample it doesnt seem like there would ever be any carriage returns. So your parsing could be as simple as:

Substitute ( "2~11~Test ID~4/19/2012 12:23:51 PM~USER~123.123.123.123"; "~"; ¶ ) or

Substitute ( YourRawField; "~"; ¶ )

Then you can use GetValue ( ) to grab the value that you want.

[madhatt]

Perfect-O!

Thanks so much that's exactly what I was looking for.