lyoungstratus

## gist:ad4cfdf442517e1769144ee7fc6709d0

To extract transactions from an Apple card PDF statement to a tab delimited text under Powershell, you can use these commands:

pdftotext  -table '.\Apple Card Statement - October 2019.pdf'

$regex = '^(\d\d)/(\d\d)/(20\d\d)\s+(.*?)\s+\S*%\s+\$\S+\s*(.*)'

get-content '.\Apple Card Statement - October 2019.txt' | where-object {
    ($_ -replace "\s+"," ") -match $regex
} | foreach-object {

	To extract transactions from an Apple card PDF statement to a tab delimited text under Powershell, you can use these commands:

	pdftotext -table '.\Apple Card Statement - October 2019.pdf'

	$regex = '^(\d\d)/(\d\d)/(20\d\d)\s+(.?)\s+\S%\s+\$\S+\s(.)'

	get-content '.\Apple Card Statement - October 2019.txt' \| where-object {
	($_ -replace "\s+"," ") -match $regex
	} \| foreach-object {