Hi All,
I am Importing the Data from Text File. The Issue is this Particular Fields Say Item Code it has two patterns of Data.
Pattern A: 3040-403-R1123-40
Pattern B: 3040403R1123 40.
In the Script when I am Importing as Follows:
@252:271T AS [Item Code], I cant Mention Maxstring as the Pattern B makes up with spaces for the Special Characters Spaces.
My question is what condition should I use so that the Data only of the Pattern B is Imported ?
Any Help will be appreciated.
Thanks,
Madu