Help in converting a delimited data file (Tab) or as PDF file

R

ronmill66

New Member
Joined
Mar 24, 2018
Messages
1
Hi,

This is my first post and I hope I can get some help. I know the very basic of macros. I work on testing macros at home using excel 2003 vba, but at work I use a excel 2016. R3C2 is for a chk# or name/R3C1 is for 2 or 3 digit empl. #/R3c5 is information for adjusting transaction/r3c6 - r3c12 is for numbers/amts. currently I'm having to enter all postings manually in its respective spot. Below is an abbreviated file that is used. It is formated as Delimited and not delimited data. Help would be much appreciated.


IS_INTERNAL_YN INTERNAL_DEBIT INTERNAL_CREDIT FIRST FIRST_DEBIT FIRST_CREDIT SECOND SECOND_DEBIT SECOND_CREDIT THIRD THIRD_DEBIT THIRD_CREDIT EXP_DATE RECEIPT_NO GUEST_FULL_NAME TARGET_RESORT TRX_DESC MARKET_CODE BUSINESS_FORMAT_DATE BUSINESS_TIME BUSINESS_DATE REFERENCE TRX_NO CASHIER_DEBIT CASHIER_CREDIT ROOM CREDIT_CARD_SUPPLEMENT CURRENCY1 TRX_CODE CASHIER_ID REMARK INSERT_USER INSERT_DATE CHEQUE_NUMBER ROOM_CLASS CC_CODE CASHIER_NAME USER_NAME DEP_NET_TAX_AMT DEPOSIT_DEBIT CASH_ID_USER_NAME PRINT_CASHIER_DEBIT PRINT_CASHIER_CREDIT
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Gilmartin,Allan Pinon Grill Bkfst Food CTR 03-02-18 08:06 AM 02-MAR-18 Room# 246 : CHECK# 9771 [75] 115145150 -3.5 0 246 Room# 246 : CHECK# 9771 [75] USD 2000 2004 122 02-MAR-18 977120180302070953 DLX [Micros 9700 Enhanced] POS (200) OPERA-IFC 0 0 2004-OPERA-IFC -3.5 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 F&B CASH 9510 Pinon Grill Bkfst Food HSE 03-02-18 08:39 AM 02-MAR-18 CHECK# 9787 [75] 115145318 -3.5 0 9510 CHECK# 9787 [75] USD 2000 2004 122 02-MAR-18 978720180302083119 PI [Micros 9700 Enhanced] POS (200) OPERA-IFC 0 0 2004-OPERA-IFC -3.5 0

N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 F&B CASH 9510 Pinon Grill Lunch Food HSE 03-02-18 03:48 PM 02-MAR-18 CHECK# 9830 [81] 115149335 -1.5 0 9510 CHECK# 9830 [81] USD 2010 2004 122 02-MAR-18 983020180302153602 PI [Micros 9700 Enhanced] POS (200) OPERA-IFC 0 0 2004-OPERA-IFC -1.5 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Bloomfield,Anthony Pinon Grill Lunch Food CTR 03-02-18 03:49 PM 02-MAR-18 Room# 338 : CHECK# 9827 [81] 115149339 -11 0 338 Room# 338 : CHECK# 9827 [81] USD 2010 2004 122 02-MAR-18 982720180302150323 DLX [Micros 9700 Enhanced] POS (200) OPERA-IFC 0 0 2004-OPERA-IFC -11 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Williamson,Daniel Rm Svc Dinner Food CTR 03-02-18 04:28 PM 02-MAR-18 Room# 353 : CHECK# 4030 [81] 115149110 -4.63 0 353 Room# 353 : CHECK# 4030 [81] USD 2398 2004 122 02-MAR-18 403020180302155634 DLX [Micros 9700 Enhanced] POS (200) OPERA-IFC 0 0 2004-OPERA-IFC -4.63 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miles,Paul Rm Svc Dinner Food CTR 03-02-18 04:29 PM 02-MAR-18 Room# 345 : CHECK# 4031 [81] 115149574 -3.5 0 345 Room# 345 : CHECK# 4031 [81] USD 2398 2004 122 02-MAR-18 403120180302155712 DLX [Micros 9700 Enhanced] POS (200) OPERA-IFC 0 0 2004-OPERA-IFC -3.5 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Ehlers,Lesley Pinon Grill Lunch Food CTR 03-02-18 04:36 PM 02-MAR-18 Room# 355 : CHECK# 9841 [81] 115149601 -2.25 0 355 Room# 355 : CHECK# 9841 [81] USD 2010 2004 122 02-MAR-18 984120180302163422 DLX [Micros 9700 Enhanced] POS (200) OPERA-IFC 0 0 2004-OPERA-IFC -2.25 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Tax Pinon Grill Food-City HSE 03-02-18 02:49 AM 02-MAR-18 115166980 -.48 0 9518 CHK98907, COMP CHIPS FOR TABLE #90 USD 7230 3200 CHK98907, COMP CHIPS FOR TABLE #90 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -.48 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Pinon Grill Lunch Food HSE 03-02-18 02:52 AM 02-MAR-18 115166981 -21.62 0 9518 CHK98917, PSPRT #601-88-2911 JAN/19 USD 2010 3200 CHK98917, PSPRT #601-88-2911 JAN/19 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -21.62 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Pinon Grill Lunch Beer HSE 03-02-18 02:53 AM 02-MAR-18 115166982 -1.54 0 9518 CHK98917, PSPRT #601-88-2911 JAN/19 USD 2011 3200 CHK98917, PSPRT #601-88-2911 JAN/19 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -1.54 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Tax Pinon Grill Food-City HSE 03-02-18 02:53 AM 02-MAR-18 115166983 -1.84 0 9518 CHK98917, PSPRT #601-88-2911 JAN/19 USD 7230 3200 CHK98917, PSPRT #601-88-2911 JAN/19 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -1.84 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Pinon Grill Dinner Food HSE 03-02-18 02:55 AM 02-MAR-18 115166984 -17.26 0 9518 CHK9870, REST.COM CERT#165303824 USD 2020 3200 CHK9870, REST.COM CERT#165303824 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -17.26 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Pinon Grill Dinner Liquor HSE 03-02-18 02:56 AM 02-MAR-18 115166985 -1.88 0 9518 CHK9870, REST.COM CERT#165303824 USD 2022 3200 CHK9870, REST.COM CERT#165303824 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -1.88 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Pinon Grill Dinner Grat HSE 03-02-18 02:56 AM 02-MAR-18 115166986 -4.02 0 9518 CHK9870, REST.COM CERT#165303824 USD 2026 3200 CHK9870, REST.COM CERT#165303824 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -4.02 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Tax Pinon Grill Food-City HSE 03-02-18 02:56 AM 02-MAR-18 115166987 -1.84 0 9518 CHK9870, REST.COM CERT#165303824 USD 7230 3200 CHK9870, REST.COM CERT#165303824 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -1.84 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 F&B Visa 9512 Tax Pinon Grill Food-City HSE 03-02-18 03:01 AM 02-MAR-18 115166988 -2.5 0 9512 CHK9811, SERVER CLOSED WRONG CHECK AND RECALCUATED TAX USD 7230 3200 CHK9811, SERVER CLOSED WRONG CHECK AND RECALCUATED TAX 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -2.5 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 F&B Visa 9512 Pinon Grill Lunch Grat HSE 03-02-18 03:14 AM 02-MAR-18 115166990 -5.38 0 9512 CHK9811, SERVER ADJUSTED CHK TO PUT DISCOUNT. BUT UNABLE TO REOPEN CHK PROPERLY. THEREFORE, DID NOT CORRECTLY CALCULATE. USD 2016 3200 CHK9811, SERVER ADJUSTED CHK TO PUT DISCOUNT. BUT UNABLE TO REOPEN CHK PROPERLY. THEREFORE, DID NOT CORRECTLY CALCULATE. 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -5.38 0
R_DEBIT R_CREDIT LOGO
-742.67 -483.02
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
You must log in or register to reply here.

Forum statistics

Threads
1,214,641
Messages
6,120,695
Members
448,979
Latest member
DET4492

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top