Hi to the forum, Please help me it is very urgent for me i have a text file which is (|) delimited in which it contains all countries files, what i want to do is to create country wise files in .TXT same format. so there will be singapore.txt india.txt etc.
i tried but i was not able to complete what i did i imported this file in excel sheet after then was able to export but i was not able to create country wise multiple text files file is attached please view it and give response -- Pankaj Kumar -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
DETAIL|3|2010-08-31|1|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|CACODE|DR|+500.0000||||||||500.0000|SGD|702|1.0000|SGD|702|2010-08-26|Cash|1|2010-08-26|5||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|2|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|CACODE|DR|+500.0000||||||||500.0000|SGD|702|1.0000|SGD|702|2010-08-26|Cash|1|2010-08-26|6||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|3|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||60|REG|Airfare|2010-08-13|SGD|1.0000|M|N|AGM London||British Airways|N|R||||Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||SG||||0.0000|1800.0000|1800.0000|1800.0000|1800.0000|COPD|Company Paid|||||||||||||||||||||||||||||||SG||HOME|||Company|Company/Employee Pseudo Payment Code|Company Paid|Company Paid|50500010|DR|+1800.0000|502|||||||||||||||||||60|100.0000|Asia|Singapore|CSL|Support Team|GT0A20||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|4|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||62|CHD|Hotel|2010-08-15|GBP|2.2000|M|N|AGM in London||Hilton London|N|R||||Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||GB||||0.0000|440.0000|200.0000|440.0000|440.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|50500010|DR|+440.0000|497|||||||||||||||||||62|100.0000|Asia|Singapore|CSL|Support Team|GT0A20||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|5|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||62|CHD|Hotel|2010-08-15|GBP|2.2000|M|N|AGM in London||Hilton London|N|R||||Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||GB||||0.0000|440.0000|200.0000|440.0000|440.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Employee|Company/Employee Pseudo Payment Code|Company|Company/Employee Pseudo Payment Code|CACODE|CR|-390.0000|503|||||||500.0000|SGD|702|1.0000|SGD|702|2010-08-26|Cash|2|2010-08-26|5||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|6|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||62|CHD|Hotel|2010-08-15|GBP|2.2000|M|N|AGM in London||Hilton London|N|R||||Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||GB||||0.0000|440.0000|200.0000|440.0000|440.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Employee|Company/Employee Pseudo Payment Code|Company|Company/Employee Pseudo Payment Code|CACODE|CR|-50.0000|504|||||||500.0000|SGD|702|1.0000|SGD|702|2010-08-26|Cash|2|2010-08-26|6||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|7|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||63|CHD|Hotel|2010-08-16|GBP|2.2000|M|N|AGM in London||Hilton London|N|R||||Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||GB||||0.0000|440.0000|200.0000|440.0000|440.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|50500010|DR|+440.0000|498|||||||||||||||||||63|100.0000|Asia|Singapore|CSL|Support Team|GT0A20||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|8|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||63|CHD|Hotel|2010-08-16|GBP|2.2000|M|N|AGM in London||Hilton London|N|R||||Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||GB||||0.0000|440.0000|200.0000|440.0000|440.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Employee|Company/Employee Pseudo Payment Code|Company|Company/Employee Pseudo Payment Code|CACODE|CR|-440.0000|505|||||||500.0000|SGD|702|1.0000|SGD|702|2010-08-26|Cash|2|2010-08-26|6||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|9|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||64|CHD|Hotel|2010-08-17|GBP|2.2000|M|N|AGM in London||Hilton London|N|R||||Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||GB||||0.0000|440.0000|200.0000|440.0000|440.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|50500010|DR|+430.0000|494|||||||||||||||||||64|100.0000|Asia|Singapore|CSL|Support Team|GT0A20||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|10|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||64|CHD|Hotel|2010-08-17|GBP|2.2000|M|N|AGM in London||Hilton London|N|R||||Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||GB||||0.0000|440.0000|200.0000|440.0000|440.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|50500010|DR|+10.0000|499|||||||||||||||||||64|100.0000|Asia|Singapore|CSL|Support Team|GT0A20||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|11|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||64|CHD|Hotel|2010-08-17|GBP|2.2000|M|N|AGM in London||Hilton London|N|R||||Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||GB||||0.0000|440.0000|200.0000|440.0000|440.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Employee|Company/Employee Pseudo Payment Code|Company|Company/Employee Pseudo Payment Code|CACODE|CR|-10.0000|506|||||||500.0000|SGD|702|1.0000|SGD|702|2010-08-26|Cash|2|2010-08-26|6||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|12|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||65|REG|Company Logo|2010-08-20|SGD|1.0000|M|N|Office maintenance||Logo Inc|N|R||||Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||SG||||0.0000|200.0000|200.0000|200.0000|200.0000|CASH|Cash|||||||||||||||||||||||||||||||SG||HOME|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|50350029|DR|+200.0000|495|||||||||||||||||||65|100.0000|Asia|Singapore|CSL|Support Team|GT0A20||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|13|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||66|REG|Medical Health|2010-08-11|SGD|1.0000|M|N|HR approval|||N|R||||Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||SG||||0.0000|60.0000|60.0000|60.0000|60.0000|CASH|Cash|||||||||||||||||||||||||||||||SG||HOME|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|GL|DR|+60.0000|500|||||||||||||||||||66|100.0000|Asia|Singapore|CSL|Support Team|GT0A20||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|14|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||66|REG|Medical Health|2010-08-11|SGD|1.0000|M|N|HR approval|||N|R||||Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||SG||||0.0000|60.0000|60.0000|60.0000|60.0000|CASH|Cash|||||||||||||||||||||||||||||||SG||HOME|||Employee|Company/Employee Pseudo Payment Code|Company|Company/Employee Pseudo Payment Code|CACODE|CR|-60.0000|507|||||||500.0000|SGD|702|1.0000|SGD|702|2010-08-26|Cash|2|2010-08-26|5||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|15|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||67|REG|Entertainment - Meals|2010-08-17|SGD|1.0000|M|N|Demo||Demo|N|R|1||1|Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||SG||||0.0000|200.0000|200.0000|200.0000|200.0000|CASH|Cash|||||||||||||||||||||||||||||||SG||HOME|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|50500010|DR|+200.0000|496|||||||||||||||||||67|100.0000|Asia|Singapore|CSL|Support Team|GT0A20||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|16|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||68|REG|BCA|2010-08-04|SGD|1.0000|M|N|BCA||BCA|N|N||||Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||SG||||0.0000|50.0000|50.0000|50.0000|50.0000|CASH|Cash|||||||||||||||||||||||||||||||SG||HOME|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|50350029|DR|+50.0000|501|||||||||||||||||||68|100.0000|Asia|Singapore|CSL|Support Team|GT0A20||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|17|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support Team|GT0A20|||||8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC - Report 1 with cash advance|N|N|N|3630.0000|3630.0000|Carrier Singapore Expense Policy||Asia|Singapore|CSL|Support Team|GT0A20||Yes||||||||||||||||||||68|REG|BCA|2010-08-04|SGD|1.0000|M|N|BCA||BCA|N|N||||Asia|Singapore|CSL|Support Team|GT0A20|||SG&A|||||||||||||||||||||||||||||||||SG||||0.0000|50.0000|50.0000|50.0000|50.0000|CASH|Cash|||||||||||||||||||||||||||||||SG||HOME|||Employee|Company/Employee Pseudo Payment Code|Company|Company/Employee Pseudo Payment Code|CACODE|CR|-50.0000|508|||||||500.0000|SGD|702|1.0000|SGD|702|2010-08-26|Cash|2|2010-08-26|5||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|18|1389|Ahir|Nitish|M||Asia|India|1000|RLC Sales - West|1134|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|140009|DR|+4000.0000||||||||4000.0000|INR|356|1.0000|INR|356|2010-08-27|Cash|1|2010-08-27|7||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|19|1389|Ahir|Nitish|M||Asia|India|1000|RLC Sales - West|1134|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|140009|DR|+2000.0000||||||||2000.0000|INR|356|1.0000|INR|356|2010-08-31|Cash|1|2010-08-31|9||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|20|1389|Ahir|Nitish|M||Asia|India|1000|RLC Sales - West|1134|||||C1DCD233F3634DD185F8|46|INDIA|INR|INDIA|2010-08-31|2010-08-31|2010-08-31|Nitish - Report #1|N|N|N|8795.0000|8695.0000|Carrier India Expense Policy||Asia|India|1000|RLC Sales - West|1134||Yes||||||||||||||||||||220|REG|Airfare - International|2010-08-11|INR|1.0000|M|N|London conference||British Airways|N|R||||Asia|India|1000|RLC Sales - West|1134||||||||||||||||||||||||||||||||||||IN||||0.0000|4000.0000|4000.0000|4000.0000|4000.0000|COPD|Company Paid|||||||||||||||||||||||||||||||IN||HOME|||Company|Company/Employee Pseudo Payment Code|Company Paid|Company Paid|503504|DR|+4000.0000|2599|||||||||||||||||||224|100.0000|Asia|India|1000|RLC Sales - West|1134|||||||||||||||||||||||||||||||||||||||||||||A.Request #1|28000.0000|27000.0000|2010-09-19|2010-09-25|2010-08-31||||||||||| DETAIL|3|2010-08-31|21|1389|Ahir|Nitish|M||Asia|India|1000|RLC Sales - West|1134|||||C1DCD233F3634DD185F8|46|INDIA|INR|INDIA|2010-08-31|2010-08-31|2010-08-31|Nitish - Report #1|N|N|N|8795.0000|8695.0000|Carrier India Expense Policy||Asia|India|1000|RLC Sales - West|1134||Yes||||||||||||||||||||224|CHD|Hotel (International)|2010-08-17|GBP|73.9000|M|N|London conference||Hilton London|N|R||||Asia|India|1000|RLC Sales - West|1134||||||||||||||||||||||||||||||||||||GB||||0.0000|2956.0000|40.0000|2956.0000|2956.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|503504|DR|+2956.0000|2595|||||||||||||||||||228|100.0000|Asia|India|1000|RLC Sales - West|1134|||||||||||||||||||||||||||||||||||||||||||||A.Request #1|28000.0000|27000.0000|2010-09-19|2010-09-25|2010-08-31||||||||||| DETAIL|3|2010-08-31|22|1389|Ahir|Nitish|M||Asia|India|1000|RLC Sales - West|1134|||||C1DCD233F3634DD185F8|46|INDIA|INR|INDIA|2010-08-31|2010-08-31|2010-08-31|Nitish - Report #1|N|N|N|8795.0000|8695.0000|Carrier India Expense Policy||Asia|India|1000|RLC Sales - West|1134||Yes||||||||||||||||||||225|CHD|Meals/Refreshment (International)|2010-08-17|GBP|73.9000|M|N|London conference||Hilton London|N|R||||Asia|India|1000|RLC Sales - West|1134||||||||||||||||||||||||||||||||||||GB||||0.0000|739.0000|10.0000|739.0000|739.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|503504|DR|+739.0000|2596|||||||||||||||||||229|100.0000|Asia|India|1000|RLC Sales - West|1134|||||||||||||||||||||||||||||||||||||||||||||A.Request #1|28000.0000|27000.0000|2010-09-19|2010-09-25|2010-08-31||||||||||| DETAIL|3|2010-08-31|23|1389|Ahir|Nitish|M||Asia|India|1000|RLC Sales - West|1134|||||C1DCD233F3634DD185F8|46|INDIA|INR|INDIA|2010-08-31|2010-08-31|2010-08-31|Nitish - Report #1|N|N|N|8795.0000|8695.0000|Carrier India Expense Policy||Asia|India|1000|RLC Sales - West|1134||Yes||||||||||||||||||||228|REG|Entertainment - Meals|2010-08-18|INR|1.0000|M|N|Concur meeting||Tikka restaurant|N|R|2||1|Asia|India|1000|RLC Sales - West|1134||||||||||||||||||||||||||||||||||||IN||||0.0000|500.0000|500.0000|500.0000|500.0000|CASH|Cash|||||||||||||||||||||||||||||||IN||HOME|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|507529|DR|+500.0000|2597|||||||||||||||||||232|100.0000|Asia|India|1000|RLC Sales - West|1134||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|24|1389|Ahir|Nitish|M||Asia|India|1000|RLC Sales - West|1134|||||C1DCD233F3634DD185F8|46|INDIA|INR|INDIA|2010-08-31|2010-08-31|2010-08-31|Nitish - Report #1|N|N|N|8795.0000|8695.0000|Carrier India Expense Policy||Asia|India|1000|RLC Sales - West|1134||Yes||||||||||||||||||||229|REG|Periodicals/Newspaper/Book Subscriptions|2010-08-19|INR|1.0000|M|N|Magazines||ACCA|N|N||||Asia|India|1000|RLC Sales - West|1134||||||||||||||||||||||||||||||||||||IN||||0.0000|500.0000|600.0000|600.0000|500.0000|CASH|Cash|||||||||||||||||||||||||||||||IN||HOME|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|508000|DR|+500.0000|2598|||||||||||||||||||233|100.0000|Asia|India|1000|RLC Sales - West|1134||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|25|CCL050388|Lu|Lu| ||Asia|China|3080|041|60829074125|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|101015|DR|+2000.0000||||||||2000.0000|CNY|156|1.0000|CNY|156|2010-08-23|Cash|1|2010-08-23|3||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|26|CCL050388|Lu|Lu| ||Asia|China|3080|041|60829074125|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|101015|DR|+5000.0000||||||||5000.0000|CNY|156|1.0000|CNY|156|2010-08-26|Cash|1|2010-08-26|4||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|27|CCL050388|Lu|Lu| ||Asia|China|3080|041|60829074125|||||4E11CA0EF3AB4D2E81EF|15|CHINA|CNY|CHINA|2010-08-26|2010-08-26|2010-08-31|LuLu - Medical Report|N|N|N|200.0000|200.0000|Carrier China Expense Policy||Asia|China|3080|041|60829074125||No||||||||||||||||||||41|REG|Medical Health|2010-08-05|CNY|1.0000|M|N|Demo|||N|R||||Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||CN||||0.0000|200.0000|200.0000|200.0000|200.0000|CASH|Cash|||||||||||||||||||||||||||||||CN|CN-31|HOME|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|221160|DR|+200.0000|2513|||||||||||||||||||41|100.0000|Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|28|CCL050388|Lu|Lu| ||Asia|China|3080|041|60829074125|||||D623E0E4CC7C4ABB8A22|16|CHINA|CNY|CHINA|2010-08-26|2010-08-26|2010-08-26|Lulu - London & everything else|N|N|N|31106.0000|31106.0000|Carrier China Expense Policy||Asia|China|3080|041|60829074125||Yes||||||||||||||||||||42|REG|Airfare - International|2010-08-25|CNY|1.0000|M|N|AGM in London||British Airways|N|R||||Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||CN||||0.0000|20000.0000|20000.0000|20000.0000|20000.0000|COPD|Company Paid|||||||||||||||||||||||||||||||CN|CN-31|HOME|||Company|Company/Employee Pseudo Payment Code|Company Paid|Company Paid|660009|DR|+20000.0000|366|||||||||||||||||||42|100.0000|Asia|China|3080|041|60829074125|||||||||||||||||||||||||||||||||||||||||||||LuLu - Trip To London|32000.0000|32000.0000|||2010-08-25||||||||||| DETAIL|3|2010-08-31|29|CCL050388|Lu|Lu| ||Asia|China|3080|041|60829074125|||||D623E0E4CC7C4ABB8A22|16|CHINA|CNY|CHINA|2010-08-26|2010-08-26|2010-08-26|Lulu - London & everything else|N|N|N|31106.0000|31106.0000|Carrier China Expense Policy||Asia|China|3080|041|60829074125||Yes||||||||||||||||||||44|CHD|Hotel (International)|2010-08-10|GBP|11.5100|M|N|AGM in London||Hilton|N|R||||Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||GB||||0.0000|2302.0000|200.0000|2302.0000|2302.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|660010|DR|+2302.0000|363|||||||||||||||||||44|100.0000|Asia|China|3080|041|60829074125|||||||||||||||||||||||||||||||||||||||||||||LuLu - Trip To London|32000.0000|32000.0000|||2010-08-25||||||||||| DETAIL|3|2010-08-31|30|CCL050388|Lu|Lu| ||Asia|China|3080|041|60829074125|||||D623E0E4CC7C4ABB8A22|16|CHINA|CNY|CHINA|2010-08-26|2010-08-26|2010-08-26|Lulu - London & everything else|N|N|N|31106.0000|31106.0000|Carrier China Expense Policy||Asia|China|3080|041|60829074125||Yes||||||||||||||||||||44|CHD|Hotel (International)|2010-08-10|GBP|11.5100|M|N|AGM in London||Hilton|N|R||||Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||GB||||0.0000|2302.0000|200.0000|2302.0000|2302.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Employee|Company/Employee Pseudo Payment Code|Company|Company/Employee Pseudo Payment Code|101015|CR|-2302.0000|367|||||||5000.0000|CNY|156|1.0000|CNY|156|2010-08-26|Cash|2|2010-08-26|4|||||||||||||||||||||||||||||||||||||||||||||||||||||LuLu - Trip To London|32000.0000|32000.0000|||2010-08-25||||||||||| DETAIL|3|2010-08-31|31|CCL050388|Lu|Lu| ||Asia|China|3080|041|60829074125|||||D623E0E4CC7C4ABB8A22|16|CHINA|CNY|CHINA|2010-08-26|2010-08-26|2010-08-26|Lulu - London & everything else|N|N|N|31106.0000|31106.0000|Carrier China Expense Policy||Asia|China|3080|041|60829074125||Yes||||||||||||||||||||45|CHD|Hotel (International)|2010-08-11|GBP|11.5100|M|N|AGM in London||Hilton|N|R||||Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||GB||||0.0000|2302.0000|200.0000|2302.0000|2302.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|660010|DR|+2302.0000|364|||||||||||||||||||45|100.0000|Asia|China|3080|041|60829074125|||||||||||||||||||||||||||||||||||||||||||||LuLu - Trip To London|32000.0000|32000.0000|||2010-08-25||||||||||| DETAIL|3|2010-08-31|32|CCL050388|Lu|Lu| ||Asia|China|3080|041|60829074125|||||D623E0E4CC7C4ABB8A22|16|CHINA|CNY|CHINA|2010-08-26|2010-08-26|2010-08-26|Lulu - London & everything else|N|N|N|31106.0000|31106.0000|Carrier China Expense Policy||Asia|China|3080|041|60829074125||Yes||||||||||||||||||||45|CHD|Hotel (International)|2010-08-11|GBP|11.5100|M|N|AGM in London||Hilton|N|R||||Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||GB||||0.0000|2302.0000|200.0000|2302.0000|2302.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Employee|Company/Employee Pseudo Payment Code|Company|Company/Employee Pseudo Payment Code|101015|CR|-2302.0000|368|||||||5000.0000|CNY|156|1.0000|CNY|156|2010-08-26|Cash|2|2010-08-26|4|||||||||||||||||||||||||||||||||||||||||||||||||||||LuLu - Trip To London|32000.0000|32000.0000|||2010-08-25||||||||||| DETAIL|3|2010-08-31|33|CCL050388|Lu|Lu| ||Asia|China|3080|041|60829074125|||||D623E0E4CC7C4ABB8A22|16|CHINA|CNY|CHINA|2010-08-26|2010-08-26|2010-08-26|Lulu - London & everything else|N|N|N|31106.0000|31106.0000|Carrier China Expense Policy||Asia|China|3080|041|60829074125||Yes||||||||||||||||||||46|CHD|Hotel (International)|2010-08-12|GBP|11.5100|M|N|AGM in London||Hilton|N|R||||Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||GB||||0.0000|2302.0000|200.0000|2302.0000|2302.0000|CASH|Cash|||||||||||||||||||||||||||||||GB|GB-GTL|FRGN|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|660010|DR|+2302.0000|359|||||||||||||||||||46|100.0000|Asia|China|3080|041|60829074125|||||||||||||||||||||||||||||||||||||||||||||LuLu - Trip To London|32000.0000|32000.0000|||2010-08-25||||||||||| DETAIL|3|2010-08-31|34|CCL050388|Lu|Lu| ||Asia|China|3080|041|60829074125|||||D623E0E4CC7C4ABB8A22|16|CHINA|CNY|CHINA|2010-08-26|2010-08-26|2010-08-26|Lulu - London & everything else|N|N|N|31106.0000|31106.0000|Carrier China Expense Policy||Asia|China|3080|041|60829074125||Yes||||||||||||||||||||47|REG|Telephone & Fax Charges (Telephone)|2010-08-24|CNY|1.0000|M|N|July phone bill|||N|R||||Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||CN||||0.0000|1000.0000|1000.0000|1000.0000|1000.0000|CASH|Cash|||||||||||||||||||||||||||||||CN|CN-31|HOME|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|660003|DR|+1000.0000|360|||||||||||||||||||47|100.0000|Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|35|CCL050388|Lu|Lu| ||Asia|China|3080|041|60829074125|||||D623E0E4CC7C4ABB8A22|16|CHINA|CNY|CHINA|2010-08-26|2010-08-26|2010-08-26|Lulu - London & everything else|N|N|N|31106.0000|31106.0000|Carrier China Expense Policy||Asia|China|3080|041|60829074125||Yes||||||||||||||||||||48|REG|Housing Expense (Utility)|2010-08-16|CNY|1.0000|M|N|HR benefits||NA|N|R||||Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||CN||||0.0000|2800.0000|2800.0000|2800.0000|2800.0000|CASH|Cash|||||||||||||||||||||||||||||||CN|CN-31|HOME|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|221162|DR|+2800.0000|361|||||||||||||||||||48|100.0000|Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|36|CCL050388|Lu|Lu| ||Asia|China|3080|041|60829074125|||||D623E0E4CC7C4ABB8A22|16|CHINA|CNY|CHINA|2010-08-26|2010-08-26|2010-08-26|Lulu - London & everything else|N|N|N|31106.0000|31106.0000|Carrier China Expense Policy||Asia|China|3080|041|60829074125||Yes||||||||||||||||||||49|REG|Entertainment - Meals|2010-08-11|CNY|1.0000|M|N|Concur demo||Phoenix Restaurant|N|N|1||1|Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||CN||||0.0000|400.0000|400.0000|400.0000|400.0000|CASH|Cash|||||||||||||||||||||||||||||||CN|CN-31|HOME|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|660006|DR|+4.0000|362|||||||||||||||||||49|100.0000|Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|37|CCL050388|Lu|Lu| ||Asia|China|3080|041|60829074125|||||D623E0E4CC7C4ABB8A22|16|CHINA|CNY|CHINA|2010-08-26|2010-08-26|2010-08-26|Lulu - London & everything else|N|N|N|31106.0000|31106.0000|Carrier China Expense Policy||Asia|China|3080|041|60829074125||Yes||||||||||||||||||||49|REG|Entertainment - Meals|2010-08-11|CNY|1.0000|M|N|Concur demo||Phoenix Restaurant|N|N|1||1|Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||CN||||0.0000|400.0000|400.0000|400.0000|400.0000|CASH|Cash|||||||||||||||||||||||||||||||CN|CN-31|HOME|||Company|Company/Employee Pseudo Payment Code|Employee|Company/Employee Pseudo Payment Code|660006|DR|+396.0000|365|||||||||||||||||||49|100.0000|Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| DETAIL|3|2010-08-31|38|CCL050388|Lu|Lu| ||Asia|China|3080|041|60829074125|||||D623E0E4CC7C4ABB8A22|16|CHINA|CNY|CHINA|2010-08-26|2010-08-26|2010-08-26|Lulu - London & everything else|N|N|N|31106.0000|31106.0000|Carrier China Expense Policy||Asia|China|3080|041|60829074125||Yes||||||||||||||||||||49|REG|Entertainment - Meals|2010-08-11|CNY|1.0000|M|N|Concur demo||Phoenix Restaurant|N|N|1||1|Asia|China|3080|041|60829074125||||||||||||||||||||||||||||||||||||CN||||0.0000|400.0000|400.0000|400.0000|400.0000|CASH|Cash|||||||||||||||||||||||||||||||CN|CN-31|HOME|||Employee|Company/Employee Pseudo Payment Code|Company|Company/Employee Pseudo Payment Code|101015|CR|-396.0000|369|||||||5000.0000|CNY|156|1.0000|CNY|156|2010-08-26|Cash|2|2010-08-26|4|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
