Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
We are storing XYZ column data into 5 columns.
Req: If length of data is 2 digit it should be store in Lavel1 column, If its 4 then it should be store in Lavel2 column, If its 7 then it should be store in Level3...etc.
How we are getting data now:
How we actually need:
Help Note: We are getting 1st column value in 2nd column with some additional values, Like
if there is 20 in 1st column(LVL1) then in 2nd column its 20+02=2002. same for next column like value in 2nd column is 2002 then value in 3rd column is 2002+255=2002255.
I need logic at script level not expression Level.
Thanks In advance.
Sagar
Share the clear requirement? From where the number 1002 comes from?
All 1 to 3 Level data is coming from one(XYZ) column and that data we are storing in to 3 columns as per the logic that is if there is 2 digit it should be 1level, if count of value is 4 its should be level 2 and if length of value is 7 its should be store in level 3 column.
Thanks,
Sagar Pawar.