Hi All,
I have a requirement like 1 -record need to be split into mutiple columns
Ex:Record:Batch 2|| incident ||casue||0001-10-09 00:00:00(Database)
I need to populate data according the table columns
==============================
Column name Datavalue
==============================
Batch Batch2
group incident
reason Cause
Date 0001-10-09 00:00:00
===================================
Please suggest me which stage i need to use and impliment
Thanks and Regards
Srini
Spliting Record in to multiple columns
Moderators: chulett, rschirm, roy
Specifically the Field() function can be used to break up your pipe delimited string. Because of the double pipes, you'll need to adjust your 'field number' accordingly. For example, "incident" would be the third (not second) field.
The 'sub fields' could then be broken further down using the same function.
The 'sub fields' could then be broken further down using the same function.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers