In Progress

Comparing str key and xml string key att

ok, It is simple script task, but time and performance should be an issue. I have wrote php script that can do these:

1. Extract string keys and values from csv source file.

2. Checking target xml file and see there are any matching string keys.

3. If there are matching then check its string value.

4. And save all the data in csv form.

So here are samples:

//source csv

## Airbrush=

@@Foo_HOB_Art_Studio_wordclueName_AirbrushGun=Airbrush Gun

@@Foo_HOB_Curio_Shoppe_wordclueName_Airbrush=Airbrush

## Alarm=

@@Foo_CAD_Bank_Vault_wordclueName_AlarmClock=Alarm Clock

@@Foo_HOB_Garage_Sale_wordclueName_AlarmClock=Alarm Clock

@@Foo_HOB_Russian_Front_wordclueName_Alarm=Alarm

@@Foo_HOB_Window_Shopping_wordclueName_FireAlarm=Fire Alarm

//target xml

<?xml version="1.0" encoding="UTF-8"?>

<strings locale="ko_KR">

<pkg name="Achievements">

<string key="@@Foo_HOB_Art_Studio_wordclueName_AirbrushGun">

<original>&#49457;&#52712;</original>

</string>

<string key="@@Foo_HOB_Russian_Front_wordclueName_Alarm">

<original>&#52629;&#54616;&#54633;&#45768;&#45796;</original>

</string>

<string key="@@Foo_HOB_Garage_Sale_wordclueName_AlarmClock">

<original>&#54925;&#46301;&#54664;&#49845;&#45768;&#45796;!</original>

<variation index="0">&#54925;&#46301;&#54664;&#49845;&#45768;&#45796;!</variation>

</string>

<string key="@@Foo_HOB_Garage_Sale_wordclueName_AlarmClock">

<original>&#54925;&#46301;&#54664;&#49845;&#45768;&#45796;!</original>

<variation index="0">&#54925;&#46301;&#54664;&#49845;&#45768;&#45796;!</variation>

</string>

<string key="@@Foo_CAD_Bank_Vault_wordclueName_AlarmClock">

<original>&#54925;&#46301;&#54664;&#49845;&#45768;&#45796;!</original>

<variation index="0">&#54925;&#46301;&#54664;&#49845;&#45768;&#45796;!</variation>

</string>

<string key="@@Foo_HOB_Window_Shopping_wordclueName_FireAlarm">

<original>&#54925;&#46301;&#54664;&#49845;&#45768;&#45796;!</original>

<variation index="0">&#54925;&#46301;&#54664;&#49845;&#45768;&#45796;!</variation>

</string>

<string key="@@Foo_HOB_Art_Studio_wordclueName_Airbrush">

<original>&#49457;&#52712;</original>

</string>

</pkg>

</strings>

//result csv

Airbrush

@@Foo_HOB_Art_Studio_wordclueName_AirbrushGun=Airbrush Gun

@@Foo_HOB_Art_Studio_wordclueName_AirbrushGun=&#49457;&#52712;

@@Foo_HOB_Curio_Shoppe_wordclueName_Airbrush=Airbrush

@@Foo_HOB_Curio_Shoppe_wordclueName_Airbrush=&#49457;&#52712;

Alarm

@@Foo_CAD_Bank_Vault_wordclueName_AlarmClock=Alarm Clock

@@Foo_CAD_Bank_Vault_wordclueName_AlarmClock=&#54925;&#46301;&#54664;&#49845;&#45768;&#45796;!

@@Foo_HOB_Garage_Sale_wordclueName_AlarmClock=Alarm Clock

@@Foo_HOB_Garage_Sale_wordclueName_AlarmClock=&#54925;&#46301;&#54664;&#49845;&#45768;&#45796;!

@@Foo_HOB_Russian_Front_wordclueName_Alarm=Alarm

@@Foo_HOB_Russian_Front_wordclueName_Alarm=&#52629;&#54616;&#54633;&#45768;&#45796;

@@Foo_HOB_Window_Shopping_wordclueName_FireAlarm=Fire Alarm

@@Foo_HOB_Window_Shopping_wordclueName_FireAlarm=&#54925;&#46301;&#54664;&#49845;&#45768;&#45796;!

That is all. As I said, I have wrote php script that is working only small size of files. Source file is like 350k but the target xml file is like 4MB, and my script takes too long to do this.

I attach real source and target file. Check it. ;-)

Skills: Linux, PHP, Python, Shell Script

See more: to string, string the, string i, string 2, matching strings, matching string, data str, string matching, str, python task, python strings, gun, fire name, att, small python task, php alarm, python extract, python csv xml, csv xml python, working string, issue checking, xml variation, small xml task, python xml file, time string

About the Employer:
( 7 reviews ) CA, United States

Project ID: #1280344

Awarded to:

gangabass

I can do this for you. See PM for details.

$40 USD in 0 days
(140 Reviews)
6.0

2 freelancers are bidding on average $70 for this job

freelance4hire80

pls check pm

$100 USD in 2 days
(17 Reviews)
4.5