I can use if it is a single row to split the data.

But in my case from my source file, there is "Department" column which has more than 3000 rows...

I mean in the C# script in post-execute, how to declare the columns

Dept_L1,Dept_L2,Dept_L3,Dept_L4,Dept_L5,Dept_L6,Dept_7

to get the respective values in between the "=+ form the source.

"Futurewei Technologies, Inc.=N.A. Region=Usa=Products & Solutions=US Research...

can someone help with the code in c# for the above scenario

Could you give me an example as I'am new to C#.

I even dont know how to write the code.

Appreciate your thanks very much.

Hi,

Thanks for the reply. But in my scenario I have to take the string values between "="

and break them into 7 levels.

So for which option I should go, Substringmethod,IdexOf Method...

Yes, I have read but how do i declare in the script to break the text into 7 levels.

Please help me with the c# code.

Thannks

i'am new to c# script can you tell me how to code my above scenario in the script component

My input in DT_NTEXT and I have changed to DT_WSTR.

There are no null data in the column.

Can someone tell how we can do it script component

can anyone tell how can we right the expression for the above scenario in derived column?

errors while running are the following:

1. [Derived Column [986]] Error: An error occurred while evaluating...

HI,

I have a record like "Futurewei Technologies, Inc.=N.A. Region=Usa=Products & Solutions=US Research Center=America Network Division=America Network Optical Dept".

Now I need to split it up into 7 levels based on "=".

I...