Hi all ,
I have strings in the source data file as below
Basically this is a smart list .. I am trying to write a rule file for this as below to load to essbase
If ABC replace with 0
If ABC -0.5 replace with 1
If ABC -1 replace with 2 etc ...
But whenever there is a space in the record like above ( ABC -0.5) this rule is giving the record as 1 -0.5 . that is it is initially replacing the ABC as 1.
I tried to give option as Match whole word ... in the rule file but thisd is not getting enabled if there is a space in the field . If i give ABC-0.5(that is wihtout spaces) then "Macth whole word " option is working out.
Please let me knoe how to handle this in rule file.
Thanks in advance
You should correct that in your source file rather than trying to adjust it in load rule. Imagine that you did achieve it by splitting and joining the columns back, what will happen when one day it starts coming without a space?