Hi,
Please help to get result for below scenario. I have field called location where some paths are available. I need to keep all paths started with C: or c: as it is and remaining drives i need to replace with 'OtherThanC'
EX: Original values - f:\link\linkng630
Result should be - OtherThanC:\link\linkng630
| Location |
| U:\Users\Center\appdata\roaming\microsoft\windows\start menu\programs\startup |
| u:\users\center\appdata\roaming\microsoft\windows\start menu\programs\startup |
| V: |
| v: |
| v:\program files |
| v:\program files\dbs |
| f:\link\linkng630 |
| f:\link\linkng630\lng |
| D:\program files (x86) |
| d:\program files (x86) |
| c:\windows\syswow64\adobe\director |
| C:\windows\syswow64\adobe\shockwave 12 |
| c:\windows\syswow64\adobe\shockwave 12 |
| c:\windows\syswow64\adobe\svg viewer |
| c:\windows\syswow64\adobe\svg viewer 3.0 |
I have tried using replace, subfield functions but cannot able to get this result. This is sample data and path could be anything irrespective of depth of path.
Can anyone help me how to create new field using 'Location' field to get accurate result?
Thanks alot.
Raju
