search

sandeepmohan23 / yfai_data_migration

YFAI Data Migration
0 stars 0 forks source link

ng4LaunchSite value split into yf5_MfgRegion and yf5_LeadMfgCountry #49

Open rajender2k opened 7 years ago

rajender2k commented 7 years ago

Hi Prem, I'm capturing the issue we discussed today.

Example 1: Current behavior SRC: ng4LaunchSite="AD TORSLANDA\,EU,AD TORSLANDA\,EU"

TGT: yf5_MfgRegion="EU" yf5_LeadMfgCountry="AD TORSLANDA\"

Desired behavior yf5_MfgRegion="EU" yf5_LeadMfgCountry="AD TORSLANDA" In the value escape character() should not exists

Example 2:
**Current behavior**
SRC:
ng4LaunchSite="Dearborn\, MI\, USA\,NA,Kansas City\, MO\, USA\,NA"

TGT:
yf5_MfgRegion=" MI\" yf5_LeadMfgCountry="Dearborn\"

**Desired behavior**
**yf5_MfgRegion="NA" yf5_LeadMfgCountry="Dearborn\, MI\, USA"**

In the value escape character(\) should not exists

Please let us know if this possible or not

Thanks Raj

rajender2k commented 7 years ago

Example 1: Current behavior SRC: ng4LaunchSite="AD TORSLANDA\,EU,AD TORSLANDA\,EU"

TGT: yf5_MfgRegion="EU" yf5_LeadMfgCountry="AD TORSLANDA\"

Desired behavior yf5_MfgRegion="EU" yf5_LeadMfgCountry="AD TORSLANDA" In the value escape character() should not exists

Siemens-PLM commented 7 years ago

try using a replace <attribute name="yf5_MfgRegion" value="@ng4LaunchSite.Split(',')[1].Replace('\b','')"/> <attribute name="yf5_LeadMfgCountry" value="@ng4LaunchSite.Split(',')[0].Replace('\b','')"/>