Cleaning up legacy text strings in fields

[Greenman]

Small mess to clean up: I have two street address fields: street_1 and street_2. However, there are times when 2 street lines haven't been enough. Users have added two lines of text separated by hard return to either street_1 or street_2 indescriminately. (Unfortunately.)

I need to find those fields with hard returns in them, and create new fields new_street_1, new_street_2 and new_street_3 based on the original street fields without damaging the original data so I can clean it up reliably. What script operation will work best to accomplish this goal?

Is there a better way?

[Raybaudi]

Show all records

Go to Record [ first ]

Loop

Set Field [ YourTable::new_street_1 ; GetValue ( List ( YourTable::street_1 ; YourTable::street_2 ) ; 1 ) ]

Set Field [ YourTable::new_street_2 ; GetValue ( List ( YourTable::street_1 ; YourTable::street_2 ) ; 2 ) ]

Set Field [ YourTable::new_street_3 ; GetValue ( List ( YourTable::street_1 ; YourTable::street_2 ) ; 3 ) ]

Go to Record [ next ; exit after last ]

End Loop

[Greenman]

Thanks! I'll give it a shot and report back. Again, Cheers!

[Greenman]

Wow, I thought I'd reported back on this. It's a little late but it worked well. Better late than never. Thanks for the tip.