Joined: 22 Jun 2010
Online Status: Offline
Posts: 11
Topic: Parsing a text field Posted: 11 Apr 2013 at 7:57am
How do you parse a text field in Crystal? The data is derived from a SQL db, varchar(5000), and the field I need is delimited by commas.
Aside from knowing there could be dates or social security numbers among other things, there is no way of predicting the length or format of each element in the field. There may even be some text, with spaces.
Joined: 01 Mar 2013
Location: United States
Online Status: Offline
Posts: 35
Posted: 12 Apr 2013 at 3:06am
You said field delimited by commas. So, is this field ALWAYS after the 1st or 2nd or whatever number of commas? If so, then you can match to find the position of that 1st/2nd/3rd comma, cut the text from there up to the next found comma. I have done something similar before. Can you show an example of your data?
Joined: 22 Jun 2010
Online Status: Offline
Posts: 11
Posted: 12 Apr 2013 at 10:36am
Understood.
Further research indicates that parsing is not the solution. I just need to id the text field in question (by another field) to determine what sort of data it contains.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged